package com.dks.mapper;

import java.util.*;

import com.dks.dto.QsMailJsonDto;
import com.dks.models.QsMail;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

@Mapper
public interface QsMailMapper{

    Integer insert(QsMail qsMail);

    Integer update(QsMail qsMail);

    Integer delete(@Param("id") Integer id);

    QsMail select(@Param("id") Integer id);

    QsMailJsonDto selectQsMailJsonDto(@Param("id") Long id);

    QsMailJsonDto selectOverClassQsMailJsonDto(@Param("id") Long id);

    Integer cntByMap(Map<String, Object> map);

    List<Integer> getByMap(Map<String, Object> map);

    List<QsMail> getByMapList(Map<String, Object> map);

    Integer updateByCode(QsMail qsMail);

    QsMail selectByBfCode(@Param("bfCode") String bfCode);

    int updateReadAllQsMail(QsMail qsMail);
}
